/**
 * Students wich will choise a company have to got relation with year and company
 */

const Sequelize = require('sequelize');
const MySQLManager = require('../utils/MySQLManager');


const Internship = MySQLManager.define('internship', {

    // 学生的年度
	student_year: {
        type: Sequelize.STRING,
        allowNull: false,
        unique: 'name',
    },

    //   学生学号
	student_user_name: {
		type: Sequelize.STRING,
        allowNull: false,
        unique: 'name',
    },

    //   岗位名称
    company_name: {
        type: Sequelize.STRING,
        defaultValue: ''
    },

    
    //   岗位id
    company_id: {
        type: Sequelize.STRING,
        defaultValue: ''
    },

    //   教师编号
    teacher_user_name: {
        type: Sequelize.STRING
    },

    //   教师姓名
    teacher_user_fullname: {
        type: Sequelize.STRING
    },

    // 成绩
    grade: {
        type: Sequelize.STRING,
        defaultValue: 'X'
    },

    // 状态 0未报名， 1已报名
    student_status: {
        type: Sequelize.STRING,
        defaultValue: '0'
    },

    // 是否被锁定  1 否 0 是
    is_locked: {
        type: Sequelize.INTEGER,
        defaultValue: '1'
    }

  


    // //   备用字段
	//   beiyong1: {
	// 	type: Sequelize.STRING
	//   },
	//   beiyong2: {
	// 	type: Sequelize.STRING
	//   },
	//   beiyong3: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong4: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong5: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong6: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong7: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong8: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong9: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong10: {
	// 	type: Sequelize.STRING
	//   }
});


module.exports = Internship